100
How can I programmatically change the column where incremental searching is performed

Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("Column 1")
oTree.Columns.Add("Column 2")
var_Items = oTree.Items
	' var_Items.CellCaption(var_Items.AddItem("Item 1"),1) = "SubItem 1"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellCaption(AddItem(`Item 1`),1) = `SubItem 1`"

oTree.SearchColumnIndex = 1

99
How do I disable the full-row selection in the control

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.FullRowSelect = .f.
oTree.Columns.Add("Column")
oTree.Items.AddItem("One")
oTree.Items.AddItem("Two")

98
Is there any option to specify the height of the items, before adding them

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.DefaultItemHeight = 32
oTree.Columns.Add("Column")
oTree.Items.AddItem("One")
oTree.Items.AddItem("Two")

97
How do lock / fix some columns to the control, so I can see them all the time, event if I scroll the columns

Dim oTree as P
Dim var_Column as local
Dim var_Column1 as local
Dim var_Column2 as local
Dim var_Column3 as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.CountLockedColumns = 1
oTree.BackColorLock = 15790320
oTree.ColumnAutoResize = .f.
' oTree.Columns.Add("Locked").Width = 128
var_Column = oTree.Columns.Add("Locked")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Width = 128"

' oTree.Columns.Add("Un-Locked 1").Width = 128
var_Column1 = oTree.Columns.Add("Un-Locked 1")
oTree.TemplateDef = "dim var_Column1"
oTree.TemplateDef = var_Column1
oTree.Template = "var_Column1.Width = 128"

' oTree.Columns.Add("Un-Locked 2").Width = 128
var_Column2 = oTree.Columns.Add("Un-Locked 2")
oTree.TemplateDef = "dim var_Column2"
oTree.TemplateDef = var_Column2
oTree.Template = "var_Column2.Width = 128"

' oTree.Columns.Add("Un-Locked 3").Width = 128
var_Column3 = oTree.Columns.Add("Un-Locked 3")
oTree.TemplateDef = "dim var_Column3"
oTree.TemplateDef = var_Column3
oTree.Template = "var_Column3.Width = 128"

var_Items = oTree.Items
	' var_Items.CellCaption(var_Items.AddItem("locked"),1) = "unlocked"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellCaption(AddItem(`locked`),1) = `unlocked`"


96
How do I change the control's background / foreground color on the locked area

Dim oTree as P
Dim var_Column as local
Dim var_Column1 as local
Dim var_Column2 as local
Dim var_Column3 as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.CountLockedColumns = 1
oTree.ForeColorLock = 15790320
oTree.BackColorLock = 8421504
oTree.ColumnAutoResize = .f.
' oTree.Columns.Add("Locked").Width = 128
var_Column = oTree.Columns.Add("Locked")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Width = 128"

' oTree.Columns.Add("Un-Locked 1").Width = 128
var_Column1 = oTree.Columns.Add("Un-Locked 1")
oTree.TemplateDef = "dim var_Column1"
oTree.TemplateDef = var_Column1
oTree.Template = "var_Column1.Width = 128"

' oTree.Columns.Add("Un-Locked 2").Width = 128
var_Column2 = oTree.Columns.Add("Un-Locked 2")
oTree.TemplateDef = "dim var_Column2"
oTree.TemplateDef = var_Column2
oTree.Template = "var_Column2.Width = 128"

' oTree.Columns.Add("Un-Locked 3").Width = 128
var_Column3 = oTree.Columns.Add("Un-Locked 3")
oTree.TemplateDef = "dim var_Column3"
oTree.TemplateDef = var_Column3
oTree.Template = "var_Column3.Width = 128"

var_Items = oTree.Items
	' var_Items.CellCaption(var_Items.AddItem("locked"),1) = "unlocked"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellCaption(AddItem(`locked`),1) = `unlocked`"


95
How do I change the control's foreground color

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.ForeColor = 7895160
oTree.Columns.Add("Column")
oTree.Items.AddItem("item")

94
How do I change the control's background color

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.BackColor = 13158600

93
How do I use my own icons for my radio buttons

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oTree.Template = "RadioImage(0) = 1" // oTree.RadioImage(.f.) = 1
oTree.Template = "RadioImage(1) = 2" // oTree.RadioImage(.t.) = 2
' oTree.Columns.Add("Radio").Def(1) = .t.
var_Column = oTree.Columns.Add("Radio")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Def(1) = True"

var_Items = oTree.Items
	var_Items.AddItem("Radio 1")
	' var_Items.CellState(var_Items.AddItem("Radio 2"),0) = 1
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellState(AddItem(`Radio 2`),0) = 1"

	var_Items.AddItem("Radio 3")

92
How do I use my own icons for checkbox cells

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oTree.Template = "CheckImage(0) = 1" // oTree.CheckImage(0) = 1
oTree.Template = "CheckImage(1) = 2" // oTree.CheckImage(1) = 2
' oTree.Columns.Add("Check").Def(0) = .t.
var_Column = oTree.Columns.Add("Check")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Def(0) = True"

var_Items = oTree.Items
	var_Items.AddItem("Check 1")
	' var_Items.CellState(var_Items.AddItem("Check 2"),0) = 1
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellState(AddItem(`Check 2`),0) = 1"


91
How do I perform my own sorting when user clicks the column's header

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.SortOnClick = 1
oTree.Columns.Add("Column")
oTree.Items.AddItem("Item 1")
oTree.Items.AddItem("Item 2")

90
How do I disable sorting a specified column when clicking its header
Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("1")
' oTree.Columns.Add("NoSort").AllowSort = .f.
var_Column = oTree.Columns.Add("NoSort")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.AllowSort = False"


89
How do I disable sorting the columns when clicking the control's header
Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.SortOnClick = 0
oTree.Columns.Add("1")
oTree.Columns.Add("2")

88
How do I put a picture on the center of the control

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
oTree.PictureDisplay = 17

87
How do I resize/stretch a picture on the control's background

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
oTree.PictureDisplay = 49

86
How do I put a picture on the control's center right bottom side

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
oTree.PictureDisplay = 34

85
How do I put a picture on the control's center left bottom side

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
oTree.PictureDisplay = 32

84
How do I put a picture on the control's center top side

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
oTree.PictureDisplay = 1

83
How do I put a picture on the control's right top corner

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
oTree.PictureDisplay = 2

82
How do I put a picture on the control's left top corner

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")
oTree.PictureDisplay = 0

81
How do I put a picture on the control's background

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Picture = oTree.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)")

80
How do I sort descending a column, and put the sorting icon in the column's header

Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("Column")
var_Items = oTree.Items
	var_Items.AddItem("Item 1")
	var_Items.AddItem("Item 2")
	var_Items.AddItem("Item 3")
oTree.Columns.Item(0).SortOrder = 2

79
How do I sort ascending a column, and put the sorting icon in the column's header

Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("Column")
var_Items = oTree.Items
	var_Items.AddItem("Item 3")
	var_Items.AddItem("Item 1")
	var_Items.AddItem("Item 2")
oTree.Columns.Item(0).SortOrder = 1

78
How do I perform my own/custom sort, using my extra strings

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("desc").SortType = 5
var_Column = oTree.Columns.Add("desc")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.SortType = 5"

var_Items = oTree.Items
	' var_Items.CellData(var_Items.AddItem("A"),0) = "C"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellData(AddItem(`A`),0) = `C`"

	' var_Items.CellData(var_Items.AddItem("B"),0) = "B"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellData(AddItem(`B`),0) = `B`"

	' var_Items.CellData(var_Items.AddItem("C"),0) = "A"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellData(AddItem(`C`),0) = `A`"

	var_Items.SortChildren(0,0,.f.)

77
How do I perform my own/custom sort, using my extra numbers

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("desc").SortType = 5
var_Column = oTree.Columns.Add("desc")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.SortType = 5"

var_Items = oTree.Items
	' var_Items.CellData(var_Items.AddItem(0),0) = 2
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellData(AddItem(0),0) = 2"

	' var_Items.CellData(var_Items.AddItem(1),0) = 1
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellData(AddItem(1),0) = 1"

	' var_Items.CellData(var_Items.AddItem(2),0) = 0
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellData(AddItem(2),0) = 0"

	var_Items.SortChildren(0,0,.f.)

76
By default, the column gets sorted as strings, so how do I sort a column by time only

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("desc").SortType = 4
var_Column = oTree.Columns.Add("desc")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.SortType = 4"

var_Items = oTree.Items
	var_Items.AddItem("11:00")
	var_Items.AddItem("10:10")
	var_Items.AddItem("12:12")
	var_Items.SortChildren(0,0,.f.)

75
By default, the column gets sorted as strings, so how do I sort a column by date and time

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("desc").SortType = 3
var_Column = oTree.Columns.Add("desc")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.SortType = 3"

var_Items = oTree.Items
	var_Items.AddItem("1/1/2001 11:00")
	var_Items.AddItem("1/1/2001 10:10")
	var_Items.AddItem("1/3/2003")
	var_Items.SortChildren(0,0,.f.)

74
By default, the column gets sorted as strings, so how do I sort a column by dates

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("desc").SortType = 2
var_Column = oTree.Columns.Add("desc")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.SortType = 2"

var_Items = oTree.Items
	var_Items.AddItem("1/1/2001")
	var_Items.AddItem("1/2/2002")
	var_Items.AddItem("1/3/2003")
	var_Items.SortChildren(0,0,.f.)

73
How do I sort a column by numbers

Dim oTree as P
Dim var_Column as local
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("desc").SortType = 1
var_Column = oTree.Columns.Add("desc")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.SortType = 1"

var_Items = oTree.Items
	var_Items.AddItem(1)
	var_Items.AddItem(5)
	var_Items.AddItem(10)
	var_Items.SortChildren(0,0,.f.)

72
How do I hide the control's header bar

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.HeaderVisible = .f.

71
How do change the visual appearance for the control's header bar, using EBN

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oTree.BackColorHeader = 16777216

70
How do I remove the control's border
Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Appearance = 0

69
I have a hierarchy and I need to filter only root items that match, with thier childs

Dim h as N
Dim oTree as P
Dim var_Column as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = -1
oTree.FilterInclude = 3
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 240
	var_Column.Filter = "R1"
var_Items = oTree.Items
	h = var_Items.AddItem("R1")
	var_Items.InsertItem(h,,"C1")
	var_Items.InsertItem(h,,"C2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("R2")
	var_Items.InsertItem(h,,"C1")
	var_Items.InsertItem(h,,"C2")
oTree.ApplyFilter()

68
I have a hierarchy and I need to filter only root items that match, without thier childs

Dim h as N
Dim oTree as P
Dim var_Column as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = -1
oTree.FilterInclude = 2
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 240
	var_Column.Filter = "R1"
var_Items = oTree.Items
	h = var_Items.AddItem("R1")
	var_Items.InsertItem(h,,"C1")
	var_Items.InsertItem(h,,"C2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("R2")
	var_Items.InsertItem(h,,"C1")
	var_Items.InsertItem(h,,"C2")
oTree.ApplyFilter()

67
I have a hierarchy and I need to filter only parent items that match, including thier childs

Dim h as N
Dim oTree as P
Dim var_Column as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = -1
oTree.FilterInclude = 1
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 240
	var_Column.Filter = "R1"
var_Items = oTree.Items
	h = var_Items.AddItem("R1")
	var_Items.InsertItem(h,,"C1")
	var_Items.InsertItem(h,,"C2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("R2")
	var_Items.InsertItem(h,,"C1")
	var_Items.InsertItem(h,,"C2")
oTree.ApplyFilter()

66
How can I get ride/hide of the "Filter For" field

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterPattern = .f.

65
Is there any way to get listed only visible items in the drop down filter window

Dim h as N
Dim oTree as P
Dim var_Column as P
Dim var_Column1 as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = -1
oTree.Template = "Description(0) = ``" // oTree.Description(0) = ""
oTree.Template = "Description(1) = ``" // oTree.Description(1) = ""
oTree.Template = "Description(2) = ``" // oTree.Description(2) = ""
var_Column = oTree.Columns.Add("P1")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterPattern = .f.
	var_Column.FilterList = 1
var_Column1 = oTree.Columns.Add("P2")
	var_Column1.DisplayFilterButton = .t.
	var_Column1.DisplayFilterPattern = .f.
var_Items = oTree.Items
	h = var_Items.AddItem("R1")
	' var_Items.CellCaption(h,1) = "R2"
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.CellCaption(h,1) = `R2`"

	' var_Items.CellCaption(var_Items.InsertItem(h,,"Cell 1.1"),1) = "Cell 1.2"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellCaption(InsertItem(h,,`Cell 1.1`),1) = `Cell 1.2`"

	' var_Items.CellCaption(var_Items.InsertItem(h,,"Cell 2.1"),1) = "Cell 2.2"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellCaption(InsertItem(h,,`Cell 2.1`),1) = `Cell 2.2`"


64
How do I filter for items that match exactly the specified string

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 240
	var_Column.Filter = "Item 1"
oTree.Items.AddItem("Item 1")
oTree.Items.AddItem("Item 2")
oTree.Items.AddItem("Item 3")
oTree.ApplyFilter()

63
How can I can I programmatically filter for items with a specified icon assigned

Dim oTree as P
Dim var_Column as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 10
	var_Column.Filter = 1
var_Items = oTree.Items
	' var_Items.CellImage(var_Items.AddItem("Image 1"),0) = 1
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellImage(AddItem(`Image 1`),0) = 1"

	' var_Items.CellImage(var_Items.AddItem("Image 1"),0) = 1
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellImage(AddItem(`Image 1`),0) = 1"

	' var_Items.CellImage(var_Items.AddItem("Image 2"),0) = 2
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellImage(AddItem(`Image 2`),0) = 2"

	' var_Items.CellImage(var_Items.AddItem("Image 3"),0) = 3
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellImage(AddItem(`Image 3`),0) = 3"

oTree.ApplyFilter()

62
How can I can I programmatically filter the checked items

Dim oTree as P
Dim var_Column as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	' var_Column.Def(0) = .t.
	oTree.TemplateDef = "dim var_Column"
	oTree.TemplateDef = var_Column
	oTree.Template = "var_Column.Def(0) = True"

	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 6
	var_Column.Filter = 0
oTree.Items.AddItem(0)
var_Items = oTree.Items
	' var_Items.CellState(var_Items.AddItem(1),0) = 1
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellState(AddItem(1),0) = 1"

oTree.Items.AddItem(2)
oTree.ApplyFilter()

61
How can I can I filter programmatically the items based on some numerichal rules

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 5
	var_Column.Filter = "> 0 <= 1"
oTree.Items.AddItem(0)
oTree.Items.AddItem(1)
oTree.Items.AddItem(2)
oTree.ApplyFilter()

60
How can I can I filter programmatically the items based on a range/interval of dates

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.
	var_Column.FilterType = 4
	var_Column.Filter = "1/1/2001 to 1/1/2002"
oTree.Items.AddItem("1/1/2001")
oTree.Items.AddItem("2/1/2002")
oTree.ApplyFilter()

59
How can I can I filter programmatically given a specified pattern using wild characters like * or

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 3
	var_Column.Filter = "0*"
oTree.Items.AddItem(0)
oTree.Items.AddItem("00")
oTree.Items.AddItem(1)
oTree.Items.AddItem("11")
oTree.ApplyFilter()

58
How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oTree.ApplyFilter()

57
How can I display the column's filter

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("").DisplayFilterButton = .t.
var_Column = oTree.Columns.Add("")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.DisplayFilterButton = True"


56
How can I show only the vertical scroll bar

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.ColumnAutoResize = .t.
oTree.ScrollBars = 10
oTree.Columns.Add(1)
oTree.Columns.Add(2)

55
How can I show the control's grid lines only for added/visible items

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.MarkSearchColumn = .f.
oTree.DrawGridLines = -2
oTree.Columns.Add("Column 1")
oTree.Columns.Add("Column 2")
oTree.Items.AddItem(0)
oTree.Items.AddItem(1)
oTree.Items.AddItem(2)

54
Can I hide the hierarchy lines

Dim h as N
Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = 1
oTree.HasLines = 0
oTree.Columns.Add("Column")
var_Items = oTree.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child")

53
Can I change the style or type for the hierarchy lines

Dim h as N
Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = 1
oTree.HasLines = 2
oTree.Columns.Add("Column")
var_Items = oTree.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child")

52
Can I use my own icons for the +/- ( expand/collapse ) buttons

Dim h as N
Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oTree.LinesAtRoot = 1
oTree.HasButtons = 4
oTree.Template = "HasButtonsCustom(0) = 1" // oTree.HasButtonsCustom(.f.) = 1
oTree.Template = "HasButtonsCustom(1) = 2" // oTree.HasButtonsCustom(.t.) = 2
oTree.Columns.Add("Column")
var_Items = oTree.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child")

51
How do I change visual appearance of the +/- ( expand/collapse ) buttons

Dim h as N
Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = 1
oTree.HasButtons = 3
oTree.Columns.Add("Column")
var_Items = oTree.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child")

50
How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 6
	var_Column.Filter = 0
oTree.Template = "Description(21) = `Check_On`" // oTree.Description(21) = "Check_On"
oTree.Template = "Description(22) = `Check_Off`" // oTree.Description(22) = "Check_Off"
oTree.ApplyFilter()

49
How can I change the "Checked" caption in the drop down filter window, when I filter for checked items

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 6
oTree.Template = "Description(19) = `with check on`" // oTree.Description(19) = "with check on"
oTree.Template = "Description(20) = `with check off`" // oTree.Description(20) = "with check off"

48
How can I change the name of the week days in the drop down calendar window, being displayed when I filter items between dates

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.
oTree.Template = "Description(18) = `Du Lu Ma Mi Jo Vi Si`" // oTree.Description(18) = "Du Lu Ma Mi Jo Vi Si"
oTree.ApplyFilter()

47
How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.
oTree.Template = "Description(17) = `Janvier Février Mars Avril Mai Juin Juillet Août Septembre Octobre Novembre Décembre`" // oTree.Description(17) = "Janvier Février Mars Avril Mai Juin Juillet Août Septembre Octobre Novembre Décembre"
oTree.ApplyFilter()

46
Can I change the "Today" caption being displayed in the drop down calendar, when I filter for dates

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.
oTree.Template = "Description(16) = `Azi`" // oTree.Description(16) = "Azi"
oTree.ApplyFilter()

45
The drop down filter window displays a "to" string between two datem when I filter dates. Can I change that

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.
oTree.Template = "Description(13) = `->`" // oTree.Description(13) = "->"
oTree.ApplyFilter()

44
How can I filter the items that are between an interval/range of dates

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.
oTree.ApplyFilter()

43
Can I change the "Date:" caption when the column's drop down filter window is shown

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.
oTree.Template = "Description(12) = `Range`" // oTree.Description(12) = "Range"
oTree.ApplyFilter()

42
Can I filter for values using OR - NOT , instead AND operator

Dim oTree as P
Dim var_Column as P
Dim var_Column1 as P
Dim var_Column2 as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column 1")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
var_Column1 = oTree.Columns.Add("Column 2")
	var_Column1.DisplayFilterButton = .t.
	var_Column1.FilterType = 1
var_Column2 = oTree.Columns.Add("Column 3")
	var_Column2.DisplayFilterButton = .t.
	var_Column2.FilterType = 1
oTree.FilterCriteria = "%0 or not %1 and %2"
oTree.ApplyFilter()

41
Can I change the NOT string in the filter bar

Dim oTree as P
Dim var_Column as P
Dim var_Column1 as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column 1")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
var_Column1 = oTree.Columns.Add("Column 2")
	var_Column1.DisplayFilterButton = .t.
	var_Column1.FilterType = 2
oTree.FilterCriteria = "not %0 or %1"
oTree.Template = "Description(24) = ` ! `" // oTree.Description(24) = " ! "
oTree.Template = "Description(10) = ` ! IsBlank`" // oTree.Description(10) = " ! IsBlank"
oTree.ApplyFilter()

40
Can I change the OR string in the filter bar

Dim oTree as P
Dim var_Column as P
Dim var_Column1 as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column 1")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
var_Column1 = oTree.Columns.Add("Column 2")
	var_Column1.DisplayFilterButton = .t.
	var_Column1.FilterType = 2
oTree.FilterCriteria = "%0 or %1"
oTree.Template = "Description(23) = ` | `" // oTree.Description(23) = " | "
oTree.ApplyFilter()

39
Can I change the AND string in the filter bar

Dim oTree as P
Dim var_Column as P
Dim var_Column1 as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column 1")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
var_Column1 = oTree.Columns.Add("Column 2")
	var_Column1.DisplayFilterButton = .t.
	var_Column1.FilterType = 2
oTree.Template = "Description(11) = ` & `" // oTree.Description(11) = " & "
oTree.ApplyFilter()

38
The "IsBlank" caption shown in the control's filterbar when I select "Blanks" or "NonBlanks" items in the column's drop down filter window

Dim oTree as P
Dim var_Column as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Column = oTree.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oTree.Template = "Description(9) = `Is Empty`" // oTree.Description(9) = "Is Empty"
oTree.Template = "Description(10) = `Is Not Empty`" // oTree.Description(10) = "Is Not Empty"
oTree.ApplyFilter()

37
Is there any option to remove the tooltip when the cursor hovers the column's drop down filter window
Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column").DisplayFilterButton = .t.
var_Column = oTree.Columns.Add("Column")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.DisplayFilterButton = True"

oTree.Template = "Description(4) = ``" // oTree.Description(4) = ""
oTree.Template = "Description(5) = ``" // oTree.Description(5) = ""
oTree.Template = "Description(6) = ``" // oTree.Description(6) = ""
oTree.Template = "Description(7) = ``" // oTree.Description(7) = ""
oTree.Template = "Description(8) = ``" // oTree.Description(8) = ""
oTree.Template = "Description(14) = ``" // oTree.Description(14) = ""
oTree.Template = "Description(15) = ``" // oTree.Description(15) = ""

36
How can I change the "Filter For" caption in the column's drop down filter window

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column").DisplayFilterButton = .t.
var_Column = oTree.Columns.Add("Column")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.DisplayFilterButton = True"

oTree.Template = "Description(3) = `new caption`" // oTree.Description(3) = "new caption"

35
Can I remove the "All", "Blanks" and "NonBlanks" items in the drop down filter window

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column").DisplayFilterButton = .t.
var_Column = oTree.Columns.Add("Column")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.DisplayFilterButton = True"

oTree.Template = "Description(0) = ``" // oTree.Description(0) = ""
oTree.Template = "Description(1) = ``" // oTree.Description(1) = ""
oTree.Template = "Description(2) = ``" // oTree.Description(2) = ""

34
How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column").DisplayFilterButton = .t.
var_Column = oTree.Columns.Add("Column")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.DisplayFilterButton = True"

oTree.Template = "Description(0) = `new name for (All)`" // oTree.Description(0) = "new name for (All)"

33
How can I change the position of the column

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("Column 1")
' oTree.Columns.Add("Column 2").Position = 0
var_Column = oTree.Columns.Add("Column 2")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Position = 0"


32
Can I make strikeout the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HeaderStrikeOut = .t.
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HeaderStrikeOut = True"


31
How can I apply an strikeout font only a portion of the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HTMLCaption = "<s>Col</s>umn 1"
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<s>Col</s>umn 1`"


30
How can I get underlined only a portion of column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HTMLCaption = "<u>Col</u>umn 1"
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<u>Col</u>umn 1`"


29
How can I underline the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HeaderUnderline = .t.
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HeaderUnderline = True"


28
How can I apply an italic font only a portion of the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HTMLCaption = "<i>Col</i>umn 1"
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<i>Col</i>umn 1`"


27
Is there any option to make italic the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HeaderItalic = .t.
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HeaderItalic = True"


26
How can I bold only a portion of the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HTMLCaption = "<b>Col</b>umn 1"
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<b>Col</b>umn 1`"


25
Is there any option to bold the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").HeaderBold = .t.
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HeaderBold = True"


24
Why child items are not shown

Dim h as N
Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = -1
oTree.Columns.Add("Column 1")
var_Items = oTree.Items
	h = var_Items.AddItem("Root")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"


23
Does your control support partial-check ( three states ) feature for each column

Dim h as N
Dim oTree as P
Dim var_Column as P
Dim var_Column1 as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.LinesAtRoot = -1
var_Column = oTree.Columns.Add("P1")
	' var_Column.Def(0) = .t.
	oTree.TemplateDef = "dim var_Column"
	oTree.TemplateDef = var_Column
	oTree.Template = "var_Column.Def(0) = True"

	var_Column.PartialCheck = .t.
var_Column1 = oTree.Columns.Add("P2")
	' var_Column1.Def(0) = .t.
	oTree.TemplateDef = "dim var_Column1"
	oTree.TemplateDef = var_Column1
	oTree.Template = "var_Column1.Def(0) = True"

	var_Column1.PartialCheck = .t.
var_Items = oTree.Items
	h = var_Items.AddItem("Root")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oTree.TemplateDef = "dim var_Items,h"
	oTree.TemplateDef = var_Items
	oTree.TemplateDef = h
	oTree.Template = "var_Items.ExpandItem(h) = True"


22
Is there any option to change the color for the grid lines

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("")
oTree.DrawGridLines = -1
oTree.GridLineColor = 255

21
Can I change the font to display the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.HeaderHeight = 34
' oTree.Columns.Add("Column 1").HTMLCaption = "<font Tahoma;14>Column</font> 1"
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<font Tahoma;14>Column</font> 1`"


20
Can I change the height of the header bar

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.HeaderHeight = 32

19
Can I display multiple icons to the column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
' oTree.Columns.Add("Column 1").HTMLCaption = "1<img>1</img> 2 <img>2</img>..."
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `1<img>1</img> 2 <img>2</img>...`"


18
How can I draw grid lines only for visible items

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.MarkSearchColumn = .f.
oTree.DrawGridLines = -2
oTree.Columns.Add("Column 1")
oTree.Columns.Add("Column 2")
oTree.Items.AddItem(0)
oTree.Items.AddItem(1)
oTree.Items.AddItem(2)

17
How can I show the control's grid lines

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.MarkSearchColumn = .f.
oTree.DrawGridLines = -1
oTree.Columns.Add("Column 1")
oTree.Columns.Add("Column 2")
oTree.Items.AddItem(0)
oTree.Items.AddItem(1)
oTree.Items.AddItem(2)

16
How can I assign a different background color for the entire column

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.MarkSearchColumn = .f.
' oTree.Columns.Add("Column 1").Def(4) = 255
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Def(4) = 255"

oTree.Columns.Add("Column 2")
oTree.Items.AddItem(0)
oTree.Items.AddItem(1)
oTree.Items.AddItem(2)

15
How can I assign a check box for a cell

Dim oTree as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("Column 1")
var_Items = oTree.Items
	var_Items.AddItem(0)
	' var_Items.CellHasCheckBox(var_Items.AddItem(1),0) = .t.
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellHasCheckBox(AddItem(1),0) = True"

	var_Items.AddItem(2)

14
How can I assign checkboxes for the entire column

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Column 1").Def(0) = .t.
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Def(0) = True"

oTree.Items.AddItem(0)
oTree.Items.AddItem(1)
oTree.Items.AddItem(2)

13
How can I show both scrollbars
Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.ScrollBars = 15

12
How can I change the column's width

Dim oTree as P
Dim var_Column as local
Dim var_Column1 as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.ColumnAutoResize = .f.
' oTree.Columns.Add("Column 1").Width = 64
var_Column = oTree.Columns.Add("Column 1")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Width = 64"

' oTree.Columns.Add("Column 2").Width = 128
var_Column1 = oTree.Columns.Add("Column 2")
oTree.TemplateDef = "dim var_Column1"
oTree.TemplateDef = var_Column1
oTree.Template = "var_Column1.Width = 128"


11
How can I show or hide a column
Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Hidden").Visible = .f.
var_Column = oTree.Columns.Add("Hidden")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Visible = False"


10
How can I hide the searching column
Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.MarkSearchColumn = .f.
oTree.Columns.Add("Column 1")
oTree.Columns.Add("Column 2")
oTree.Items.AddItem()

9
Can I disable sorting a column, when the user clicks the column's header, or drag it to the sort bar
Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Unsortable").AllowSort = .f.
var_Column = oTree.Columns.Add("Unsortable")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.AllowSort = False"

oTree.Columns.Add("Sortable")

8
Is there any option to align the header to the left and the data to the right

Dim oTree as P
Dim var_Column as local
Dim var_Column1 as P
Dim var_Items as P

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("Left").Alignment = 0
var_Column = oTree.Columns.Add("Left")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Alignment = 0"

var_Column1 = oTree.Columns.Add("Right")
	var_Column1.Alignment = 2
	var_Column1.HeaderAlignment = 2
var_Items = oTree.Items
	' var_Items.CellCaption(var_Items.AddItem("left"),1) = "right"
	oTree.TemplateDef = "dim var_Items"
	oTree.TemplateDef = var_Items
	oTree.Template = "var_Items.CellCaption(AddItem(`left`),1) = `right`"


7
Can I displays a custom size picture to column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Template = "HTMLPicture(`pic1`) = `c:\exontrol\images\zipdisk.gif`" // oTree.HTMLPicture("pic1") = "c:\exontrol\images\zipdisk.gif"
oTree.HeaderHeight = 48
' oTree.Columns.Add("ColumnName").HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture"
var_Column = oTree.Columns.Add("ColumnName")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<b>HTML</b> Column <img>pic1</img> Picture`"


6
How can I insert an icon to column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
' oTree.Columns.Add("ColumnName").HTMLCaption = "<b>HTML</b> Column <img>1</img> Icon"
var_Column = oTree.Columns.Add("ColumnName")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<b>HTML</b> Column <img>1</img> Icon`"


5
How can I insert an icon to column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
' oTree.Columns.Add("ColumnName").HeaderImage = 1
var_Column = oTree.Columns.Add("ColumnName")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HeaderImage = 1"


4
How can I use HTML format in column's header

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("ColumnName").HTMLCaption = "<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn"
var_Column = oTree.Columns.Add("ColumnName")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.HTMLCaption = `<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn`"


3
How can I change/rename the column's name

Dim oTree as P
Dim var_Column as local

oTree = topparent:CONTROL_ACTIVEX1.activex
' oTree.Columns.Add("ColumnName").Caption = "NewName"
var_Column = oTree.Columns.Add("ColumnName")
oTree.TemplateDef = "dim var_Column"
oTree.TemplateDef = var_Column
oTree.Template = "var_Column.Caption = `NewName`"


2
How can I add multiple columns

Dim oTree as P
Dim var_Columns as P

oTree = topparent:CONTROL_ACTIVEX1.activex
var_Columns = oTree.Columns
	var_Columns.Add("Column 1")
	var_Columns.Add("Column 2")

1
How can I add a new column

Dim oTree as P

oTree = topparent:CONTROL_ACTIVEX1.activex
oTree.Columns.Add("ColumnName")